<!--- get employee birthday --->
<CFQUERY NAME="qryBDay" DATASOURCE=#client.company_dsn#>
	SELECT BIRTHDAY, A.FIRSTNAME, A.MIDDLENAME, A.LASTNAME
	FROM CMFPA A, CIN21PERSONALINFO B
	WHERE A.PERSONNELIDNO = '#GetEntry.PERSONNELIDNO#' AND
		  A.PERSONNELIDNO = B.PERSONNELIDNO
</CFQUERY>

<table border=0 cellpadding="1px" cellspacing=0 width="100%">
<tr>
<td class="bold">
	<CFOUTPUT>
	&nbsp;&nbsp;&nbsp;#qryBDay.FIRSTNAME# #qryBDay.MIDDLENAME# #qryBDay.LASTNAME#'s birthday is on #DateFormat(qryBDay.BIRTHDAY, "mmmm dd, yyyy")#
	</CFOUTPUT>
</td>
</tr>
</table>
